Bromley's Tuxedo Rental Cash Flow Analysis
Start Up November December January February March April
Cash On Hand  $        85,000.00  $        85,000.00  $        88,931.76  $        57,870.08  $      116,815.02  $        85,766.64  $        99,725.02
Cash Receipts
Cash Sales  $        35,000.00  $                   -    $        30,000.00  $                   -    $                   -    $                   -  
Cash From Receivables  $        60,000.00  $        45,000.00  $        50,000.00
Salary Income VEC  $        83,328.00  $        83,328.00  $        83,328.00  $        83,328.00  $        83,328.00  $        83,328.00
Loan  $      150,800.00
Total Cash Receipts  $      150,800.00  $      118,328.00  $        83,328.00  $      173,328.00  $        83,328.00  $      128,328.00  $      133,328.00
Total Cash Available  $      235,800.00  $      203,328.00  $      172,259.76  $      231,198.08  $      200,143.02  $      214,094.64  $      233,053.02
Cash paid Out
Salary Expense  $        83,328.00  $        83,328.00  $        83,328.00  $        83,328.00  $        83,328.00  $        83,328.00
Rent Expense  $          3,500.00  $          3,500.00  $          3,500.00  $          3,500.00  $          3,500.00  $          3,500.00
Repairs Expense  $              50.00  $              50.00  $              50.00  $              50.00  $              50.00  $              50.00
Alterations Expense  $          1,500.00  $          1,500.00  $          1,500.00  $          1,500.00  $          1,500.00  $          1,500.00
Dry Cleaning Expense  $          8,514.00  $          8,514.00  $          8,514.00  $          8,514.00  $          8,514.00  $          8,514.00
Advertising Expense  $          2,000.00  $          2,000.00  $          2,000.00  $          2,000.00  $          2,000.00  $          2,000.00
Supplies Expense  $            150.00  $            150.00  $            150.00  $            150.00  $            150.00  $            150.00
Insurance Expense  $            750.00  $            750.00  $            750.00  $            750.00  $            750.00  $            750.00
Misc. Expense  $            100.00  $            100.00  $            100.00  $            100.00  $            100.00  $            100.00
Payroll Taxes  $          8,957.70  $          8,957.70  $          8,957.70  $          8,957.70  $          8,957.70  $          8,957.70
Legal And Accounting  $                   -    $                   -    $                   -    $                   -    $                   -    $                   -  
Utilities Expense  $          1,875.00  $          1,875.00  $          1,875.00  $          1,875.00  $          1,875.00  $          1,875.00
Bad Debts Expense  $                   -    $                   -    $                   -    $                   -    $                   -    $                   -  
Interest Expense  $          1,508.00  $          1,501.44  $          1,494.82  $          1,488.14  $          1,481.38  $            150.80
Sub total  $                   -  
Loan Payment  $          2,163.54  $          2,163.54  $          2,163.54  $          2,163.54  $          2,163.54  $          2,163.54
Capital Purchses  $      150,800.00
Total Expenditures  $      150,800.00  $      114,396.24  $      114,389.68  $      114,383.06  $      114,376.38  $      114,369.62  $      113,039.04
Total Cash Out  $      150,800.00  $      114,396.24  $      114,389.68  $      114,383.06  $      114,376.38  $      114,369.62  $      113,039.04
Cash Balance  $        85,000.00  $        88,931.76  $        57,870.08  $      116,815.02  $        85,766.64  $        99,725.02  $      120,013.98